﻿

CREATE PROCEDURE [dbo].[proc_Project_Task_Update]
	(
		@Title nvarchar(50),
@WebType smallint,
		@Description nvarchar(200),
		@ExecDepartmentId int,
		@ExecDepartmentName nvarchar(50),
		@ExecPerson nvarchar(50),
		@ExecPersonName nvarchar(50),
@DownPerson varchar(30),
@DownPersonName nvarchar(50),
		@TypeId int,
		@TaskId uniqueidentifier
	)
AS
Begin
	Update Project_Task Set
	Title=@Title,
WebType=@WebType,
	Description=@Description,
	ExecDepartmentId=@ExecDepartmentId,
	ExecDepartmentName=@ExecDepartmentName,
	ExecPerson=@ExecPerson,
	ExecPersonName=@ExecPersonName,
DownPerson=@DownPerson,
DownPersonName=@DownPersonName,
	StartDate=GetDate(),
	TypeId=@TypeId
	Where TaskId=@TaskId
End